package com.caifu.mapper;

import com.caifu.pojo.YlCheckInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 查房信息表 Mapper 接口
 * </p>
 *
 * @author GZ
 * @since 2020-11-06
 */
public interface YlCheckInfoMapper extends BaseMapper<YlCheckInfo> {
    /**
    * 
    * 功能描述：查询检查类型
    * 
    * @Param checkName 检查名称  checkType 检查类型  pensionNo养老机构编号
    * @Return      
    * @Exception   
    * @Author  GZ
    * @Date   2020/11/10 15:42
    */
    @Select({"<script>",
            "select * from yl_check_info c where c.STATUS='1'",
            "and c.CHECK_NAME=#{checkName}",
            "and c.CHECK_TYPE=#{checkType}",
            "and c.PENSION_NO=#{pensionNo}",
            "</script>"})
    YlCheckInfo queryCheckInfoByCheckName(@Param("checkName") String checkName
            ,@Param("checkType") String checkType,@Param("pensionNo") String pensionNo);
}
